Overview: Statistics
Use this operation to calculate statistics for selected fields. Statistics can be calculated across data rows (index based) or over a time span (time based), where the average between two consecutive timestamps is used. This operation will not affect the original dataset in any way. A new dataset will be created listing the statistics for the selected fields.
These statistics can be calculated:
-
minimum
-
maximum
-
kurtosis
-
skew
-
average
-
standard deviation
-
variation.
Properties
Category: |
Transform |
Performance risk: |
Low performance risk |
Knowledge required: |
Working knowledge of the software. |
Effect on datasets
How many datasets are required to perform this operation? |
One |
Does it create a new dataset? |
Yes |
Can you reconfigure this operation? |
Yes |
Can you apply this operation to a locked dataset? |
Yes |
Does it modify the current dataset in any way? |
No |
Requirements
-
A dataset that contains at least one integer or double field.
-
To calculate statistics over a time span, the dataset must have at least one timestamp field.
Results
-
A new dataset containing the calculated statistics for the selected fields.
-
The original dataset will be unaffected by this operation.
Related topics: